package com.lilosoft.business.precity.models;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UpProMaterialExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UpProMaterialExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRowguidIsNull() {
            addCriterion("ROWGUID is null");
            return (Criteria) this;
        }

        public Criteria andRowguidIsNotNull() {
            addCriterion("ROWGUID is not null");
            return (Criteria) this;
        }

        public Criteria andRowguidEqualTo(String value) {
            addCriterion("ROWGUID =", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotEqualTo(String value) {
            addCriterion("ROWGUID <>", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidGreaterThan(String value) {
            addCriterion("ROWGUID >", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidGreaterThanOrEqualTo(String value) {
            addCriterion("ROWGUID >=", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLessThan(String value) {
            addCriterion("ROWGUID <", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLessThanOrEqualTo(String value) {
            addCriterion("ROWGUID <=", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLike(String value) {
            addCriterion("ROWGUID like", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotLike(String value) {
            addCriterion("ROWGUID not like", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidIn(List<String> values) {
            addCriterion("ROWGUID in", values, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotIn(List<String> values) {
            addCriterion("ROWGUID not in", values, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidBetween(String value1, String value2) {
            addCriterion("ROWGUID between", value1, value2, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotBetween(String value1, String value2) {
            addCriterion("ROWGUID not between", value1, value2, "rowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidIsNull() {
            addCriterion("PROJECT_ROWGUID is null");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidIsNotNull() {
            addCriterion("PROJECT_ROWGUID is not null");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidEqualTo(String value) {
            addCriterion("PROJECT_ROWGUID =", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidNotEqualTo(String value) {
            addCriterion("PROJECT_ROWGUID <>", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidGreaterThan(String value) {
            addCriterion("PROJECT_ROWGUID >", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT_ROWGUID >=", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidLessThan(String value) {
            addCriterion("PROJECT_ROWGUID <", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidLessThanOrEqualTo(String value) {
            addCriterion("PROJECT_ROWGUID <=", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidLike(String value) {
            addCriterion("PROJECT_ROWGUID like", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidNotLike(String value) {
            addCriterion("PROJECT_ROWGUID not like", value, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidIn(List<String> values) {
            addCriterion("PROJECT_ROWGUID in", values, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidNotIn(List<String> values) {
            addCriterion("PROJECT_ROWGUID not in", values, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidBetween(String value1, String value2) {
            addCriterion("PROJECT_ROWGUID between", value1, value2, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectRowguidNotBetween(String value1, String value2) {
            addCriterion("PROJECT_ROWGUID not between", value1, value2, "projectRowguid");
            return (Criteria) this;
        }

        public Criteria andProjectnoIsNull() {
            addCriterion("PROJECTNO is null");
            return (Criteria) this;
        }

        public Criteria andProjectnoIsNotNull() {
            addCriterion("PROJECTNO is not null");
            return (Criteria) this;
        }

        public Criteria andProjectnoEqualTo(String value) {
            addCriterion("PROJECTNO =", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotEqualTo(String value) {
            addCriterion("PROJECTNO <>", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoGreaterThan(String value) {
            addCriterion("PROJECTNO >", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECTNO >=", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLessThan(String value) {
            addCriterion("PROJECTNO <", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLessThanOrEqualTo(String value) {
            addCriterion("PROJECTNO <=", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLike(String value) {
            addCriterion("PROJECTNO like", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotLike(String value) {
            addCriterion("PROJECTNO not like", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoIn(List<String> values) {
            addCriterion("PROJECTNO in", values, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotIn(List<String> values) {
            addCriterion("PROJECTNO not in", values, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoBetween(String value1, String value2) {
            addCriterion("PROJECTNO between", value1, value2, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotBetween(String value1, String value2) {
            addCriterion("PROJECTNO not between", value1, value2, "projectno");
            return (Criteria) this;
        }

        public Criteria andTaskguidIsNull() {
            addCriterion("TASKGUID is null");
            return (Criteria) this;
        }

        public Criteria andTaskguidIsNotNull() {
            addCriterion("TASKGUID is not null");
            return (Criteria) this;
        }

        public Criteria andTaskguidEqualTo(String value) {
            addCriterion("TASKGUID =", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidNotEqualTo(String value) {
            addCriterion("TASKGUID <>", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidGreaterThan(String value) {
            addCriterion("TASKGUID >", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidGreaterThanOrEqualTo(String value) {
            addCriterion("TASKGUID >=", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidLessThan(String value) {
            addCriterion("TASKGUID <", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidLessThanOrEqualTo(String value) {
            addCriterion("TASKGUID <=", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidLike(String value) {
            addCriterion("TASKGUID like", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidNotLike(String value) {
            addCriterion("TASKGUID not like", value, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidIn(List<String> values) {
            addCriterion("TASKGUID in", values, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidNotIn(List<String> values) {
            addCriterion("TASKGUID not in", values, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidBetween(String value1, String value2) {
            addCriterion("TASKGUID between", value1, value2, "taskguid");
            return (Criteria) this;
        }

        public Criteria andTaskguidNotBetween(String value1, String value2) {
            addCriterion("TASKGUID not between", value1, value2, "taskguid");
            return (Criteria) this;
        }

        public Criteria andMaterialnameIsNull() {
            addCriterion("MATERIALNAME is null");
            return (Criteria) this;
        }

        public Criteria andMaterialnameIsNotNull() {
            addCriterion("MATERIALNAME is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialnameEqualTo(String value) {
            addCriterion("MATERIALNAME =", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameNotEqualTo(String value) {
            addCriterion("MATERIALNAME <>", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameGreaterThan(String value) {
            addCriterion("MATERIALNAME >", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIALNAME >=", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameLessThan(String value) {
            addCriterion("MATERIALNAME <", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameLessThanOrEqualTo(String value) {
            addCriterion("MATERIALNAME <=", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameLike(String value) {
            addCriterion("MATERIALNAME like", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameNotLike(String value) {
            addCriterion("MATERIALNAME not like", value, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameIn(List<String> values) {
            addCriterion("MATERIALNAME in", values, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameNotIn(List<String> values) {
            addCriterion("MATERIALNAME not in", values, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameBetween(String value1, String value2) {
            addCriterion("MATERIALNAME between", value1, value2, "materialname");
            return (Criteria) this;
        }

        public Criteria andMaterialnameNotBetween(String value1, String value2) {
            addCriterion("MATERIALNAME not between", value1, value2, "materialname");
            return (Criteria) this;
        }

        public Criteria andGettypeIsNull() {
            addCriterion("GETTYPE is null");
            return (Criteria) this;
        }

        public Criteria andGettypeIsNotNull() {
            addCriterion("GETTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andGettypeEqualTo(String value) {
            addCriterion("GETTYPE =", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeNotEqualTo(String value) {
            addCriterion("GETTYPE <>", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeGreaterThan(String value) {
            addCriterion("GETTYPE >", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeGreaterThanOrEqualTo(String value) {
            addCriterion("GETTYPE >=", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeLessThan(String value) {
            addCriterion("GETTYPE <", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeLessThanOrEqualTo(String value) {
            addCriterion("GETTYPE <=", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeLike(String value) {
            addCriterion("GETTYPE like", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeNotLike(String value) {
            addCriterion("GETTYPE not like", value, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeIn(List<String> values) {
            addCriterion("GETTYPE in", values, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeNotIn(List<String> values) {
            addCriterion("GETTYPE not in", values, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeBetween(String value1, String value2) {
            addCriterion("GETTYPE between", value1, value2, "gettype");
            return (Criteria) this;
        }

        public Criteria andGettypeNotBetween(String value1, String value2) {
            addCriterion("GETTYPE not between", value1, value2, "gettype");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNull() {
            addCriterion("CERTIFICATE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNotNull() {
            addCriterion("CERTIFICATE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeEqualTo(String value) {
            addCriterion("CERTIFICATE_CODE =", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotEqualTo(String value) {
            addCriterion("CERTIFICATE_CODE <>", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThan(String value) {
            addCriterion("CERTIFICATE_CODE >", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_CODE >=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThan(String value) {
            addCriterion("CERTIFICATE_CODE <", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_CODE <=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLike(String value) {
            addCriterion("CERTIFICATE_CODE like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotLike(String value) {
            addCriterion("CERTIFICATE_CODE not like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIn(List<String> values) {
            addCriterion("CERTIFICATE_CODE in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotIn(List<String> values) {
            addCriterion("CERTIFICATE_CODE not in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_CODE between", value1, value2, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_CODE not between", value1, value2, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andGetnumIsNull() {
            addCriterion("GETNUM is null");
            return (Criteria) this;
        }

        public Criteria andGetnumIsNotNull() {
            addCriterion("GETNUM is not null");
            return (Criteria) this;
        }

        public Criteria andGetnumEqualTo(String value) {
            addCriterion("GETNUM =", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumNotEqualTo(String value) {
            addCriterion("GETNUM <>", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumGreaterThan(String value) {
            addCriterion("GETNUM >", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumGreaterThanOrEqualTo(String value) {
            addCriterion("GETNUM >=", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumLessThan(String value) {
            addCriterion("GETNUM <", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumLessThanOrEqualTo(String value) {
            addCriterion("GETNUM <=", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumLike(String value) {
            addCriterion("GETNUM like", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumNotLike(String value) {
            addCriterion("GETNUM not like", value, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumIn(List<String> values) {
            addCriterion("GETNUM in", values, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumNotIn(List<String> values) {
            addCriterion("GETNUM not in", values, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumBetween(String value1, String value2) {
            addCriterion("GETNUM between", value1, value2, "getnum");
            return (Criteria) this;
        }

        public Criteria andGetnumNotBetween(String value1, String value2) {
            addCriterion("GETNUM not between", value1, value2, "getnum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumIsNull() {
            addCriterion("COPIES_NUM is null");
            return (Criteria) this;
        }

        public Criteria andCopiesNumIsNotNull() {
            addCriterion("COPIES_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andCopiesNumEqualTo(Integer value) {
            addCriterion("COPIES_NUM =", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumNotEqualTo(Integer value) {
            addCriterion("COPIES_NUM <>", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumGreaterThan(Integer value) {
            addCriterion("COPIES_NUM >", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("COPIES_NUM >=", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumLessThan(Integer value) {
            addCriterion("COPIES_NUM <", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumLessThanOrEqualTo(Integer value) {
            addCriterion("COPIES_NUM <=", value, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumIn(List<Integer> values) {
            addCriterion("COPIES_NUM in", values, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumNotIn(List<Integer> values) {
            addCriterion("COPIES_NUM not in", values, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumBetween(Integer value1, Integer value2) {
            addCriterion("COPIES_NUM between", value1, value2, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andCopiesNumNotBetween(Integer value1, Integer value2) {
            addCriterion("COPIES_NUM not between", value1, value2, "copiesNum");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameIsNull() {
            addCriterion("MATERIALATTACHNAME is null");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameIsNotNull() {
            addCriterion("MATERIALATTACHNAME is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameEqualTo(String value) {
            addCriterion("MATERIALATTACHNAME =", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameNotEqualTo(String value) {
            addCriterion("MATERIALATTACHNAME <>", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameGreaterThan(String value) {
            addCriterion("MATERIALATTACHNAME >", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIALATTACHNAME >=", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameLessThan(String value) {
            addCriterion("MATERIALATTACHNAME <", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameLessThanOrEqualTo(String value) {
            addCriterion("MATERIALATTACHNAME <=", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameLike(String value) {
            addCriterion("MATERIALATTACHNAME like", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameNotLike(String value) {
            addCriterion("MATERIALATTACHNAME not like", value, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameIn(List<String> values) {
            addCriterion("MATERIALATTACHNAME in", values, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameNotIn(List<String> values) {
            addCriterion("MATERIALATTACHNAME not in", values, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameBetween(String value1, String value2) {
            addCriterion("MATERIALATTACHNAME between", value1, value2, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialattachnameNotBetween(String value1, String value2) {
            addCriterion("MATERIALATTACHNAME not between", value1, value2, "materialattachname");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesIsNull() {
            addCriterion("MATERIAL_PROPERTIES is null");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesIsNotNull() {
            addCriterion("MATERIAL_PROPERTIES is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesEqualTo(Integer value) {
            addCriterion("MATERIAL_PROPERTIES =", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesNotEqualTo(Integer value) {
            addCriterion("MATERIAL_PROPERTIES <>", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesGreaterThan(Integer value) {
            addCriterion("MATERIAL_PROPERTIES >", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesGreaterThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_PROPERTIES >=", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesLessThan(Integer value) {
            addCriterion("MATERIAL_PROPERTIES <", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesLessThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_PROPERTIES <=", value, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesIn(List<Integer> values) {
            addCriterion("MATERIAL_PROPERTIES in", values, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesNotIn(List<Integer> values) {
            addCriterion("MATERIAL_PROPERTIES not in", values, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_PROPERTIES between", value1, value2, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialPropertiesNotBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_PROPERTIES not between", value1, value2, "materialProperties");
            return (Criteria) this;
        }

        public Criteria andMaterialStateIsNull() {
            addCriterion("MATERIAL_STATE is null");
            return (Criteria) this;
        }

        public Criteria andMaterialStateIsNotNull() {
            addCriterion("MATERIAL_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialStateEqualTo(Integer value) {
            addCriterion("MATERIAL_STATE =", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateNotEqualTo(Integer value) {
            addCriterion("MATERIAL_STATE <>", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateGreaterThan(Integer value) {
            addCriterion("MATERIAL_STATE >", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_STATE >=", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateLessThan(Integer value) {
            addCriterion("MATERIAL_STATE <", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateLessThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_STATE <=", value, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateIn(List<Integer> values) {
            addCriterion("MATERIAL_STATE in", values, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateNotIn(List<Integer> values) {
            addCriterion("MATERIAL_STATE not in", values, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_STATE between", value1, value2, "materialState");
            return (Criteria) this;
        }

        public Criteria andMaterialStateNotBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_STATE not between", value1, value2, "materialState");
            return (Criteria) this;
        }

        public Criteria andCheckStateIsNull() {
            addCriterion("CHECK_STATE is null");
            return (Criteria) this;
        }

        public Criteria andCheckStateIsNotNull() {
            addCriterion("CHECK_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andCheckStateEqualTo(Integer value) {
            addCriterion("CHECK_STATE =", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotEqualTo(Integer value) {
            addCriterion("CHECK_STATE <>", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateGreaterThan(Integer value) {
            addCriterion("CHECK_STATE >", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("CHECK_STATE >=", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateLessThan(Integer value) {
            addCriterion("CHECK_STATE <", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateLessThanOrEqualTo(Integer value) {
            addCriterion("CHECK_STATE <=", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateIn(List<Integer> values) {
            addCriterion("CHECK_STATE in", values, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotIn(List<Integer> values) {
            addCriterion("CHECK_STATE not in", values, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateBetween(Integer value1, Integer value2) {
            addCriterion("CHECK_STATE between", value1, value2, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotBetween(Integer value1, Integer value2) {
            addCriterion("CHECK_STATE not between", value1, value2, "checkState");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIsNull() {
            addCriterion("CD_UPTIME is null");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIsNotNull() {
            addCriterion("CD_UPTIME is not null");
            return (Criteria) this;
        }

        public Criteria andCdUptimeEqualTo(Date value) {
            addCriterion("CD_UPTIME =", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotEqualTo(Date value) {
            addCriterion("CD_UPTIME <>", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeGreaterThan(Date value) {
            addCriterion("CD_UPTIME >", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CD_UPTIME >=", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeLessThan(Date value) {
            addCriterion("CD_UPTIME <", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeLessThanOrEqualTo(Date value) {
            addCriterion("CD_UPTIME <=", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIn(List<Date> values) {
            addCriterion("CD_UPTIME in", values, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotIn(List<Date> values) {
            addCriterion("CD_UPTIME not in", values, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeBetween(Date value1, Date value2) {
            addCriterion("CD_UPTIME between", value1, value2, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotBetween(Date value1, Date value2) {
            addCriterion("CD_UPTIME not between", value1, value2, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andDelStateIsNull() {
            addCriterion("DEL_STATE is null");
            return (Criteria) this;
        }

        public Criteria andDelStateIsNotNull() {
            addCriterion("DEL_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andDelStateEqualTo(Integer value) {
            addCriterion("DEL_STATE =", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotEqualTo(Integer value) {
            addCriterion("DEL_STATE <>", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateGreaterThan(Integer value) {
            addCriterion("DEL_STATE >", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEL_STATE >=", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateLessThan(Integer value) {
            addCriterion("DEL_STATE <", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateLessThanOrEqualTo(Integer value) {
            addCriterion("DEL_STATE <=", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateIn(List<Integer> values) {
            addCriterion("DEL_STATE in", values, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotIn(List<Integer> values) {
            addCriterion("DEL_STATE not in", values, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateBetween(Integer value1, Integer value2) {
            addCriterion("DEL_STATE between", value1, value2, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotBetween(Integer value1, Integer value2) {
            addCriterion("DEL_STATE not between", value1, value2, "delState");
            return (Criteria) this;
        }

        public Criteria andSyncSignIsNull() {
            addCriterion("SYNC_SIGN is null");
            return (Criteria) this;
        }

        public Criteria andSyncSignIsNotNull() {
            addCriterion("SYNC_SIGN is not null");
            return (Criteria) this;
        }

        public Criteria andSyncSignEqualTo(Integer value) {
            addCriterion("SYNC_SIGN =", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotEqualTo(Integer value) {
            addCriterion("SYNC_SIGN <>", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignGreaterThan(Integer value) {
            addCriterion("SYNC_SIGN >", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignGreaterThanOrEqualTo(Integer value) {
            addCriterion("SYNC_SIGN >=", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignLessThan(Integer value) {
            addCriterion("SYNC_SIGN <", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignLessThanOrEqualTo(Integer value) {
            addCriterion("SYNC_SIGN <=", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignIn(List<Integer> values) {
            addCriterion("SYNC_SIGN in", values, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotIn(List<Integer> values) {
            addCriterion("SYNC_SIGN not in", values, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignBetween(Integer value1, Integer value2) {
            addCriterion("SYNC_SIGN between", value1, value2, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotBetween(Integer value1, Integer value2) {
            addCriterion("SYNC_SIGN not between", value1, value2, "syncSign");
            return (Criteria) this;
        }

        public Criteria andCdTimeIsNull() {
            addCriterion("CD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCdTimeIsNotNull() {
            addCriterion("CD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCdTimeEqualTo(Date value) {
            addCriterion("CD_TIME =", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotEqualTo(Date value) {
            addCriterion("CD_TIME <>", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeGreaterThan(Date value) {
            addCriterion("CD_TIME >", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CD_TIME >=", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeLessThan(Date value) {
            addCriterion("CD_TIME <", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeLessThanOrEqualTo(Date value) {
            addCriterion("CD_TIME <=", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeIn(List<Date> values) {
            addCriterion("CD_TIME in", values, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotIn(List<Date> values) {
            addCriterion("CD_TIME not in", values, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeBetween(Date value1, Date value2) {
            addCriterion("CD_TIME between", value1, value2, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotBetween(Date value1, Date value2) {
            addCriterion("CD_TIME not between", value1, value2, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdBatchIsNull() {
            addCriterion("CD_BATCH is null");
            return (Criteria) this;
        }

        public Criteria andCdBatchIsNotNull() {
            addCriterion("CD_BATCH is not null");
            return (Criteria) this;
        }

        public Criteria andCdBatchEqualTo(String value) {
            addCriterion("CD_BATCH =", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotEqualTo(String value) {
            addCriterion("CD_BATCH <>", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchGreaterThan(String value) {
            addCriterion("CD_BATCH >", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchGreaterThanOrEqualTo(String value) {
            addCriterion("CD_BATCH >=", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLessThan(String value) {
            addCriterion("CD_BATCH <", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLessThanOrEqualTo(String value) {
            addCriterion("CD_BATCH <=", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLike(String value) {
            addCriterion("CD_BATCH like", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotLike(String value) {
            addCriterion("CD_BATCH not like", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchIn(List<String> values) {
            addCriterion("CD_BATCH in", values, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotIn(List<String> values) {
            addCriterion("CD_BATCH not in", values, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchBetween(String value1, String value2) {
            addCriterion("CD_BATCH between", value1, value2, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotBetween(String value1, String value2) {
            addCriterion("CD_BATCH not between", value1, value2, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andDatasourceIsNull() {
            addCriterion("DATASOURCE is null");
            return (Criteria) this;
        }

        public Criteria andDatasourceIsNotNull() {
            addCriterion("DATASOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andDatasourceEqualTo(String value) {
            addCriterion("DATASOURCE =", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotEqualTo(String value) {
            addCriterion("DATASOURCE <>", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceGreaterThan(String value) {
            addCriterion("DATASOURCE >", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceGreaterThanOrEqualTo(String value) {
            addCriterion("DATASOURCE >=", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLessThan(String value) {
            addCriterion("DATASOURCE <", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLessThanOrEqualTo(String value) {
            addCriterion("DATASOURCE <=", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLike(String value) {
            addCriterion("DATASOURCE like", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotLike(String value) {
            addCriterion("DATASOURCE not like", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceIn(List<String> values) {
            addCriterion("DATASOURCE in", values, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotIn(List<String> values) {
            addCriterion("DATASOURCE not in", values, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceBetween(String value1, String value2) {
            addCriterion("DATASOURCE between", value1, value2, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotBetween(String value1, String value2) {
            addCriterion("DATASOURCE not between", value1, value2, "datasource");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}